package br.com.sotec.lotus.core.service;

import br.com.sotec.lotus.core.beans.ChaveValor;
import br.com.sotec.lotus.core.mapper.ChaveValorMapper;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

/**
 *
 * @author glauco
 */
@Repository
public class ConsultasBaseService {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    
    public List<ChaveValor> getPaises(){
        return jdbcTemplate.query("select id_pais, nome_ptbr from pais", new ChaveValorMapper());
    }
}
